<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="FileData" targetNamespace="http://tempuri.org/FileData.xsd" xmlns:mstns="http://tempuri.org/FileData.xsd" xmlns="http://tempuri.org/FileData.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" GeneratorFunctionsComponentClassName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" UserFunctionsComponentName="QueriesTableAdapter" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="MySettings" AppSettingsPropertyName="PoserFilesConnectionString" ConnectionStringObject="" IsAppSettingsProperty="True" Modifier="Assembly" Name="PoserFilesConnectionString (MySettings)" PropertyReference="ApplicationSettings.PoserFiles.My.MySettings.GlobalReference.Default.PoserFilesConnectionString" Provider="System.Data.OleDb">
          </Connection>
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="FilesTableAdapter" GeneratorDataComponentClassName="FilesTableAdapter" Name="Files" UserDataComponentName="FilesTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="Files" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="True" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="False" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>DELETE FROM `Files` WHERE ((`file_id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_file_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>SELECT     filename, code, provider, disc, file_id, description, product_name, price, Comments, DSOnly, MinPoserVersion, vendor, product_link, installed, 
                      LocalImage, ImageName, Requirements, price_paid, file_size, date_of_download, order_number, ReadMe, license, actual_location
FROM         Files
WHERE     (file_id = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="False" AutogeneratedName="Param1" ColumnName="file_id" DataSourceName="Files" DataTypeServer="DbType.Int32" DbType="Int32" Direction="Input" ParameterName="file_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_id" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="False">
                    <CommandText>UPDATE `Files` SET `filename` = ?, `code` = ?, `provider` = ?, `disc` = ?, `description` = ?, `product_name` = ?, `price` = ?, `Comments` = ?, `DSOnly` = ?, `MinPoserVersion` = ?, `vendor` = ?, `product_link` = ?, `installed` = ?, `LocalImage` = ?, `ImageName` = ?, `Requirements` = ?, `price_paid` = ?, `file_size` = ?, `date_of_download` = ?, `order_number` = ?, `ReadMe` = ?, `license` = ?, `actual_location` = ? WHERE ((`file_id` = ?))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="filename" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="filename" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="code" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="code" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="provider" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="disc" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="disc" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="description" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="description" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="product_name" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="product_name" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="price" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="price" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Comments" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Comments" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="DSOnly" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="DSOnly" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="MinPoserVersion" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="MinPoserVersion" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="vendor" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="vendor" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="product_link" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="product_link" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="installed" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="installed" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="LocalImage" Precision="0" ProviderType="Boolean" Scale="0" Size="0" SourceColumn="LocalImage" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ImageName" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="ImageName" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="Requirements" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="Requirements" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Currency" Direction="Input" ParameterName="price_paid" Precision="0" ProviderType="Currency" Scale="0" Size="0" SourceColumn="price_paid" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="file_size" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_size" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="date_of_download" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_of_download" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="order_number" Precision="0" ProviderType="VarWChar" Scale="0" Size="0" SourceColumn="order_number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="ReadMe" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="ReadMe" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="license" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="license" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="actual_location" Precision="0" ProviderType="LongVarWChar" Scale="0" Size="0" SourceColumn="actual_location" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="False" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="Original_file_id" Precision="0" ProviderType="Integer" Scale="0" Size="0" SourceColumn="file_id" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="filename" DataSetColumn="filename" />
              <Mapping SourceColumn="code" DataSetColumn="code" />
              <Mapping SourceColumn="provider" DataSetColumn="provider" />
              <Mapping SourceColumn="disc" DataSetColumn="disc" />
              <Mapping SourceColumn="file_id" DataSetColumn="file_id" />
              <Mapping SourceColumn="description" DataSetColumn="description" />
              <Mapping SourceColumn="product_name" DataSetColumn="product_name" />
              <Mapping SourceColumn="price" DataSetColumn="price" />
              <Mapping SourceColumn="Comments" DataSetColumn="Comments" />
              <Mapping SourceColumn="DSOnly" DataSetColumn="DSOnly" />
              <Mapping SourceColumn="MinPoserVersion" DataSetColumn="MinPoserVersion" />
              <Mapping SourceColumn="vendor" DataSetColumn="vendor" />
              <Mapping SourceColumn="product_link" DataSetColumn="product_link" />
              <Mapping SourceColumn="LocalImage" DataSetColumn="LocalImage" />
              <Mapping SourceColumn="ImageName" DataSetColumn="ImageName" />
              <Mapping SourceColumn="Requirements" DataSetColumn="Requirements" />
              <Mapping SourceColumn="price_paid" DataSetColumn="price_paid" />
              <Mapping SourceColumn="file_size" DataSetColumn="file_size" />
              <Mapping SourceColumn="date_of_download" DataSetColumn="date_of_download" />
              <Mapping SourceColumn="order_number" DataSetColumn="order_number" />
              <Mapping SourceColumn="ReadMe" DataSetColumn="ReadMe" />
              <Mapping SourceColumn="license" DataSetColumn="license" />
              <Mapping SourceColumn="installed" DataSetColumn="installed" />
              <Mapping SourceColumn="actual_location" DataSetColumn="actual_location" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="PoserFilesConnectionString (MySettings)" DbObjectName="" DbObjectType="Unknown" GenerateShortCommands="True" GeneratorGetMethodName="GetDataBy" GeneratorSourceName="UpdateOrderDateAndNumber" Modifier="Public" Name="UpdateOrderDateAndNumber" QueryType="NoData" ScalarCallRetval="System.Object, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="True" UserGetMethodName="GetDataBy" UserSourceName="UpdateOrderDateAndNumber">
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="True">
                    <CommandText>UPDATE    Files
SET              date_of_download = ?, order_number = ?
WHERE     (code = ?) AND (provider = ?)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param1" ColumnName="date_of_download" DataSourceName="Files" DataTypeServer="DbType.Date" DbType="Date" Direction="Input" ParameterName="date_of_download" Precision="0" ProviderType="Date" Scale="0" Size="0" SourceColumn="date_of_download" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param2" ColumnName="order_number" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(255)" DbType="String" Direction="Input" ParameterName="order_number" Precision="0" ProviderType="WChar" Scale="0" Size="255" SourceColumn="order_number" SourceColumnNullMapping="False" SourceVersion="Current">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param3" ColumnName="code" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(50)" DbType="String" Direction="Input" ParameterName="Original_code" Precision="0" ProviderType="WChar" Scale="0" Size="50" SourceColumn="code" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                      <Parameter AllowDbNull="True" AutogeneratedName="Param4" ColumnName="provider" DataSourceName="Files" DataTypeServer="DbType.StringFixedLength(75)" DbType="String" Direction="Input" ParameterName="Original_provider" Precision="0" ProviderType="WChar" Scale="0" Size="75" SourceColumn="provider" SourceColumnNullMapping="False" SourceVersion="Original">
                      </Parameter>
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources>
        </Sources>
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="FileData" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:Generator_UserDSName="FileData" msprop:Generator_DataSetName="FileData">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="Files" msprop:Generator_UserTableName="Files" msprop:Generator_RowDeletedName="FilesRowDeleted" msprop:Generator_RowChangedName="FilesRowChanged" msprop:Generator_RowClassName="FilesRow" msprop:Generator_RowChangingName="FilesRowChanging" msprop:Generator_RowEvArgName="FilesRowChangeEvent" msprop:Generator_RowEvHandlerName="FilesRowChangeEventHandler" msprop:Generator_TableClassName="FilesDataTable" msprop:Generator_TableVarName="tableFiles" msprop:Generator_RowDeletingName="FilesRowDeleting" msprop:Generator_TablePropName="Files">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="filename" msprop:Generator_UserColumnName="filename" msprop:Generator_ColumnPropNameInRow="filename" msprop:Generator_ColumnVarNameInTable="columnfilename" msprop:Generator_ColumnPropNameInTable="filenameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="code" msprop:Generator_UserColumnName="code" msprop:Generator_ColumnPropNameInRow="code" msprop:Generator_ColumnVarNameInTable="columncode" msprop:Generator_ColumnPropNameInTable="codeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="provider" msprop:Generator_UserColumnName="provider" msprop:Generator_ColumnPropNameInRow="provider" msprop:Generator_ColumnVarNameInTable="columnprovider" msprop:Generator_ColumnPropNameInTable="providerColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="75" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="disc" msprop:Generator_UserColumnName="disc" msprop:Generator_ColumnPropNameInRow="disc" msprop:Generator_ColumnVarNameInTable="columndisc" msprop:Generator_ColumnPropNameInTable="discColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="file_id" msdata:AutoIncrement="true" msprop:Generator_UserColumnName="file_id" msprop:Generator_ColumnPropNameInRow="file_id" msprop:Generator_ColumnVarNameInTable="columnfile_id" msprop:Generator_ColumnPropNameInTable="file_idColumn" type="xs:int" />
              <xs:element name="description" msprop:Generator_UserColumnName="description" msprop:Generator_ColumnPropNameInRow="description" msprop:Generator_ColumnVarNameInTable="columndescription" msprop:Generator_ColumnPropNameInTable="descriptionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="product_name" msprop:Generator_UserColumnName="product_name" msprop:Generator_ColumnPropNameInRow="product_name" msprop:Generator_ColumnVarNameInTable="columnproduct_name" msprop:Generator_ColumnPropNameInTable="product_nameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="price" msprop:Generator_UserColumnName="price" msprop:Generator_ColumnPropNameInRow="price" msprop:Generator_ColumnVarNameInTable="columnprice" msprop:Generator_ColumnPropNameInTable="priceColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="Comments" msprop:Generator_UserColumnName="Comments" msprop:Generator_ColumnPropNameInRow="Comments" msprop:Generator_ColumnVarNameInTable="columnComments" msprop:Generator_ColumnPropNameInTable="CommentsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="DSOnly" msprop:Generator_UserColumnName="DSOnly" msprop:Generator_ColumnPropNameInRow="DSOnly" msprop:Generator_ColumnVarNameInTable="columnDSOnly" msprop:Generator_ColumnPropNameInTable="DSOnlyColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="MinPoserVersion" msprop:Generator_UserColumnName="MinPoserVersion" msprop:Generator_ColumnPropNameInRow="MinPoserVersion" msprop:Generator_ColumnVarNameInTable="columnMinPoserVersion" msprop:Generator_ColumnPropNameInTable="MinPoserVersionColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="vendor" msprop:Generator_UserColumnName="vendor" msprop:Generator_ColumnPropNameInRow="vendor" msprop:Generator_ColumnVarNameInTable="columnvendor" msprop:Generator_ColumnPropNameInTable="vendorColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="product_link" msprop:Generator_UserColumnName="product_link" msprop:Generator_ColumnPropNameInRow="product_link" msprop:Generator_ColumnVarNameInTable="columnproduct_link" msprop:Generator_ColumnPropNameInTable="product_linkColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="LocalImage" msprop:Generator_UserColumnName="LocalImage" msprop:Generator_ColumnPropNameInRow="LocalImage" msprop:Generator_ColumnVarNameInTable="columnLocalImage" msprop:Generator_ColumnPropNameInTable="LocalImageColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="ImageName" msprop:Generator_UserColumnName="ImageName" msprop:Generator_ColumnPropNameInRow="ImageName" msprop:Generator_ColumnVarNameInTable="columnImageName" msprop:Generator_ColumnPropNameInTable="ImageNameColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="Requirements" msprop:Generator_UserColumnName="Requirements" msprop:Generator_ColumnVarNameInTable="columnRequirements" msprop:Generator_ColumnPropNameInRow="Requirements" msprop:Generator_ColumnPropNameInTable="RequirementsColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="price_paid" msprop:Generator_UserColumnName="price_paid" msprop:Generator_ColumnPropNameInRow="price_paid" msprop:Generator_ColumnVarNameInTable="columnprice_paid" msprop:Generator_ColumnPropNameInTable="price_paidColumn" type="xs:decimal" minOccurs="0" />
              <xs:element name="file_size" msprop:Generator_UserColumnName="file_size" msprop:Generator_ColumnPropNameInRow="file_size" msprop:Generator_ColumnVarNameInTable="columnfile_size" msprop:Generator_ColumnPropNameInTable="file_sizeColumn" type="xs:int" minOccurs="0" />
              <xs:element name="date_of_download" msprop:Generator_UserColumnName="date_of_download" msprop:Generator_ColumnPropNameInRow="date_of_download" msprop:Generator_ColumnVarNameInTable="columndate_of_download" msprop:Generator_ColumnPropNameInTable="date_of_downloadColumn" type="xs:dateTime" minOccurs="0" />
              <xs:element name="order_number" msprop:Generator_UserColumnName="order_number" msprop:Generator_ColumnVarNameInTable="columnorder_number" msprop:Generator_ColumnPropNameInRow="order_number" msprop:Generator_ColumnPropNameInTable="order_numberColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="255" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="ReadMe" msprop:Generator_UserColumnName="ReadMe" msprop:Generator_ColumnPropNameInRow="ReadMe" msprop:Generator_ColumnVarNameInTable="columnReadMe" msprop:Generator_ColumnPropNameInTable="ReadMeColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="license" msprop:Generator_UserColumnName="license" msprop:Generator_ColumnVarNameInTable="columnlicense" msprop:Generator_ColumnPropNameInRow="license" msprop:Generator_ColumnPropNameInTable="licenseColumn" type="xs:int" minOccurs="0" />
              <xs:element name="installed" msprop:Generator_UserColumnName="installed" msprop:Generator_ColumnVarNameInTable="columninstalled" msprop:Generator_ColumnPropNameInRow="installed" msprop:Generator_ColumnPropNameInTable="installedColumn" type="xs:boolean" minOccurs="0" />
              <xs:element name="actual_location" msprop:Generator_UserColumnName="actual_location" msprop:Generator_ColumnVarNameInTable="columnactual_location" msprop:Generator_ColumnPropNameInRow="actual_location" msprop:Generator_ColumnPropNameInTable="actual_locationColumn" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="536870910" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:Files" />
      <xs:field xpath="mstns:file_id" />
    </xs:unique>
  </xs:element>
</xs:schema>